﻿CREATE TABLE [dbo].[ComprasOtros] (
    [IdCompraOtro]     INT             IDENTITY (1, 1) NOT NULL,
    [IdCompra]         INT             NOT NULL,
    [Nombre]           VARCHAR (50)    NOT NULL,
    [Cantidad]         INT             NOT NULL,
    [Precio]           DECIMAL (19, 4) NOT NULL,
    [Iva]              DECIMAL (19, 4) NOT NULL,
    [Impuesto]         DECIMAL (19, 4) NOT NULL,
    [DescuentoRecargo] DECIMAL (19, 4) NOT NULL,
    CONSTRAINT [PK_ComprasOtros] PRIMARY KEY CLUSTERED ([IdCompraOtro] ASC),
    CONSTRAINT [FK_ComprasOtros_Compras] FOREIGN KEY ([IdCompra]) REFERENCES [dbo].[Compras] ([IdCompra])
);

